package com.sky.mapper;

import com.sky.annotation.AutoFill;
import com.sky.entity.Employee;
import com.sky.enumeration.OperationType;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface EmployeeMapper {
	
	/**
	 * 根据用户名查询员工
	 *
	 * @param username
	 * @return
	 */
	@Select("select * from employee where username = #{username}")
	Employee getByUsername(String username);
	
	/**
	 * 根据名字模糊搜索或根据id查找
	 */
	List<Employee> getEmpBy(String name, Long... id);
	
	/**
	 * 新增员工
	 */
	@AutoFill(OperationType.INSERT)
	Integer insert(Employee employee);
	
	/**
	 * 更新员工
	 */
	@AutoFill(OperationType.UPDATE)
	void update(Employee employee);
}
